SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 100544 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 100544 [ RunTime:0.001773s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (296134,407513,667393,598985,1022199,403118,47683,1029857,526574,335467,69591,352011,754302,140821,722493,732968,516086,354803,175001,562789,905833,789240,643521,260042,348463,540346,667234,99014,225133,2424,538829,776937,970053,876487,68135,418518,997821,92931,317015,998419,349544,433180,858282,480174,250076,588820,108575,269669,465535,602104,894084,105633,691422,122349,172111,81266,1906,502973,497580,611128) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 100544 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 100544 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]