SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001972s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1021037 LIMIT 1 [ RunTime:0.001334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1021037 [ RunTime:0.002056s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (261025,601860,808892,210795,547672,761938,157140,907581,264954,631965,931095,259935,679784,757044,552303,266332,410439,422721,3538,524445,168880,259945,508997,188957,513935,1006582,139432,927979,39853,31891,663539,657468,967837,391956,799021,193617,984575,976973,52270,814002,910001,363578,557504,53277,36315,27445,35847,1038197,24397,213670,997635,1038837,557509,8163,108145,74616,961528,668115,905589,87059) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000988s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1021037 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1021037 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]