SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001464s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 921765 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 921765 [ RunTime:0.001585s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (922166,805998,652445,540665,300337,170658,851357,660450,117200,247532,441757,951593,20448,512072,687282,132410,257787,305098,617187,77286,859892,48832,405098,758047,830859,763063,671453,127236,1036093,421445,844683,299227,1001242,220453,743378,261005,342139,346949,206451,501118,234516,601839,403418,375667,829344,638004,690285,160356,953422,152164,1034087,765876,691533,287953,945463,275010,728139,237810,194768,413251) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001473s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 921765 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000559s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 921765 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]