SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001354s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201550 LIMIT 1 [ RunTime:0.000440s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201550 [ RunTime:0.002309s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (349568,1028400,979697,220231,754882,479407,917469,666242,997054,922318,83863,681505,349043,878779,545876,443669,900659,944140,413863,489388,553130,425293,589249,1036306,347184,342450,661459,477048,622682,115362,988656,357413,749198,27078,289878,935418,710958,76021,1044297,46534,52844,688315,1039061,49722,811189,110004,714130,142069,79036,1047495,52578,16468,63898,474508,155461,346057,67230,492659,603981,83278) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201550 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201550 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000640s ]