SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001436s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 431083 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 431083 [ RunTime:0.002033s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (210379,846951,960583,74416,717184,920176,480763,1002844,231687,872843,127003,866857,244813,627599,29880,421055,486924,587327,275706,337005,876591,478463,647621,406580,765525,835605,886832,858742,617789,817312,480714,589041,340909,617400,577494,923482,50119,251108,557970,986011,592617,863377,912552,267981,99030,895805,218917,1048220,935364,555414,879169,712666,1044851,270775,189043,742304,267740,372972,15165,1014819) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 431083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 431083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000439s ]