SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045019 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045019 [ RunTime:0.003184s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (515738,404632,117390,199775,58405,619757,312285,958146,469211,173592,567517,525417,502925,725488,621111,1005251,87310,162312,600247,32924,677856,340534,475798,81216,86539,239921,413132,853338,299670,972606,406079,800382,213899,826728,643959,249495,516659,441515,1005637,218693,789598,784061,584788,768671,39132,924727,95611,358264,387915,119662,537825,408264,98452,599097,952655,523171,29560,14746,678921,678713) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045019 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045019 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001396s ]