SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028897 LIMIT 1 [ RunTime:0.000293s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028897 [ RunTime:0.002032s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (614788,822468,444069,925899,7833,709632,359416,113675,530866,255811,848570,312429,401300,850662,951603,485285,191500,686219,979251,890809,111097,157372,963952,974573,98266,596999,892070,43653,147829,97588,364705,955328,1034777,423395,266610,214409,133941,944633,935945,749443,75326,642352,561167,932963,831233,317379,1035085,47914,209596,451699,744018,644557,837170,872866,768314,761253,759584,1001895,821065,864139) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000968s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028897 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028897 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]