SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 918504 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 918504 [ RunTime:0.001696s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (799614,343527,269650,938917,270281,199124,955484,180792,739486,987536,23964,798326,974341,4529,179972,1043428,200141,10083,297643,443823,1018815,714903,479350,448034,376310,198105,1005730,83416,852511,769959,732945,870127,258796,902786,228787,544107,65660,491898,850596,842283,1036569,1007581,89609,274834,184732,666504,606074,1033804,79002,196279,324276,689097,879399,970780,698763,354105,393309,862678,996993,198718) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 918504 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 918504 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]