SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 411218 LIMIT 1 [ RunTime:0.000446s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 411218 [ RunTime:0.001687s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (816949,926076,911144,460158,768506,194653,181001,369838,97297,357823,111765,1022208,604867,814249,146422,128919,385848,166448,424153,307808,508465,182474,356754,570494,351724,409424,671749,275909,643616,996364,304783,703424,917548,225468,373848,160440,80325,883544,246846,865735,7075,15809,734966,906371,766359,657053,263972,350258,778693,516081,160615,841171,537407,733318,1002523,208142,1032371,775453,400967,88438) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 411218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 411218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000491s ]