SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541350 LIMIT 1 [ RunTime:0.000930s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541350 [ RunTime:0.001564s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (697684,639119,930269,310273,582433,554465,843348,301017,890112,321638,914465,471096,757546,395749,858770,1012625,481940,199206,2717,986599,373687,777851,200453,1048901,190950,82117,371245,613952,760452,193035,631039,769628,753552,903142,708473,1004132,290883,1020070,875497,637132,169774,647159,388954,183861,763085,866016,798485,452527,28700,11923,25571,879595,206003,307921,415041,49911,799413,333687,311568,742809) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003676s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541350 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541350 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000756s ]