SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 43100 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 43100 [ RunTime:0.001709s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (493014,834001,114685,776368,739583,635653,327343,536318,505735,672286,7588,263798,244776,853931,742612,98197,448857,813211,404113,75033,26754,33708,270055,205952,844018,357748,395404,346178,918541,980107,679310,994905,679716,728708,482131,185728,901261,234524,652181,936292,220594,388229,381733,1047593,909326,240827,766905,574403,637028,901532,1039240,657095,454892,906102,964301,280428,819592,557300,230342,420476) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002698s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 43100 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 43100 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]