SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002669s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 336596 LIMIT 1 [ RunTime:0.001119s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 336596 [ RunTime:0.004626s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (52409,11280,436895,307980,329626,647116,558554,2389,486658,131221,602074,313814,49458,225303,222205,382921,151002,505975,599070,427638,78995,50344,322298,238350,741669,334043,770713,981252,456267,50703,494035,723570,515747,426767,206112,757479,257281,504071,8779,334690,551400,492250,464537,501402,197618,88547,396085,784233,615750,904134,443987,615561,209877,502777,1002562,809911,735395,1012841,449119,926269) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 336596 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 336596 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]