SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 49578 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 49578 [ RunTime:0.001786s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (241264,433007,755604,962671,68067,415274,952018,625293,918182,659208,474193,490678,955652,760347,76950,226082,1029365,851215,1009500,632514,29008,6981,805172,1038527,931426,623969,242394,194840,613547,460745,44920,676297,97503,410023,6841,848519,1028876,973280,457503,519002,161996,883694,704407,322626,224278,499884,725878,356472,381031,452637,212808,425689,875583,162726,120501,377954,366247,215556,589096,19976) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 49578 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000546s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 49578 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000484s ]