SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001601s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 432300 LIMIT 1 [ RunTime:0.001329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 432300 [ RunTime:0.001439s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (623537,115386,598207,147724,89223,140740,813485,86274,463677,294424,451767,483000,497822,945377,303472,256065,149986,827425,559968,745121,635076,543671,163934,110045,911443,962417,707993,90650,132481,961911,102538,888158,341021,11643,31507,752336,513621,623565,970420,54060,27600,1044417,612962,686285,800417,1005438,649680,463973,63671,560039,392799,163117,222589,716250,222185,386129,900660,66349,499900,337888) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004517s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 432300 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 432300 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003750s ]