SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003713s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 467976 LIMIT 1 [ RunTime:0.000740s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 467976 [ RunTime:0.002382s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (103863,962655,462437,204235,315046,813957,900337,571624,441817,264102,791945,886368,400959,217622,602554,898746,397992,853912,821516,688097,96782,815332,997878,308093,447449,25252,1045518,333510,438680,87894,618286,333839,4833,675915,311837,249133,344254,600032,775369,21639,751044,656303,123007,888561,199563,675571,776849,990783,730580,655915,441794,129220,896655,96530,429259,903951,133177,405388,186474,8183) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 467976 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000918s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 467976 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003481s ]