SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 97152 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 97152 [ RunTime:0.001772s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (348303,528521,1024553,142277,345887,567441,785873,569275,866840,409925,160701,790014,132669,498459,790271,866868,511697,957196,696818,776165,240340,1001619,1022038,443319,497104,54551,927872,147585,449074,195771,910777,118038,1013412,632964,636624,509758,181325,156722,680246,232686,724082,317412,323574,834226,213275,56172,123770,707728,945409,971768,657153,291437,305645,677378,117251,608042,68819,911404,164102,401730) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 97152 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000592s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 97152 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]