SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 594616 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 594616 [ RunTime:0.003331s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (784881,649319,259036,574128,977248,201901,536943,6410,216475,333870,45623,1026445,236725,149631,918486,1012671,309700,107933,582393,767051,1009081,902688,345226,197774,857922,938987,1047488,806207,415307,498561,519729,498135,1016398,247369,906559,25607,863841,415238,48242,490285,171145,481527,102809,981724,5514,617491,49150,949755,997882,471148,688244,416662,675851,204408,254380,308547,95435,344757,618361,239658) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002138s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 594616 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 594616 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000818s ]