SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 205142 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 205142 [ RunTime:0.001536s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (800906,207269,538359,376377,972164,675143,134003,924125,727586,479826,372032,44272,752850,537709,853949,293349,145837,741354,103142,404733,345386,1027570,112237,133448,29889,474148,1009141,674810,986530,866514,1010374,124222,19075,706342,531219,510281,499241,69255,940358,372001,185956,102506,600082,1038121,494132,420744,350839,324180,615451,934179,722623,622479,490663,649061,997444,27879,319457,671977,380283,1043156) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 205142 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 205142 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]