SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 424820 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 424820 [ RunTime:0.001609s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (478386,335329,86700,628737,938551,233800,646707,498764,448724,433495,257255,923323,802547,642360,1006408,19909,894657,312398,186758,54241,340117,912296,667530,597295,324977,846364,552087,353724,401627,706543,270276,322718,431946,170818,13449,131219,51916,45127,752927,289670,742458,40779,993968,245680,635362,229169,370788,988822,473418,636998,21939,31810,1033151,981606,190527,732041,246214,512099,746364,1019939) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 424820 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 424820 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000645s ]