SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 203489 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 203489 [ RunTime:0.001589s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (169181,966764,476725,981952,292597,201814,414592,829919,673522,867819,777505,500891,444927,351563,101179,685875,126653,337748,307550,363097,668935,976970,670089,785860,684232,641334,201232,128765,5160,21135,355703,1034519,740150,27900,450184,200072,9523,446150,745973,678744,1000044,1014805,140274,158547,1015609,223014,862676,657248,1028196,429115,1030464,191894,301072,800434,84843,628260,279454,607150,441203,106042) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 203489 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 203489 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]