SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801237 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801237 [ RunTime:0.002829s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (264058,30468,198145,646633,931507,274000,522783,37062,861524,869835,305529,1002742,103708,887893,955266,631054,918034,335563,583250,1018653,502614,372619,995059,648588,180427,652503,662076,1006712,601948,68341,758796,34433,138963,910647,160173,147977,107934,168733,708408,1046157,233737,4416,160204,1045794,79667,979901,586551,474270,347462,10074,554166,23282,724514,774676,808916,91523,257236,1028338,506469,404210) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801237 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801237 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]