SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001293s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001188 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001188 [ RunTime:0.001551s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (287045,123205,1041610,240302,967928,108838,92249,916189,360565,378491,469327,641948,361006,741343,856472,19487,463819,899480,1014037,128846,392074,536790,767486,98467,360929,59524,1021246,311394,452824,444913,575407,1027853,324924,199534,88446,691471,572438,542402,789767,947310,77711,656782,684087,971030,893997,390696,843641,226920,608614,717712,435688,798018,234233,110933,691203,1033262,684550,928092,832871,186522) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001188 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001188 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000430s ]