SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002376s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 444651 LIMIT 1 [ RunTime:0.006828s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 444651 [ RunTime:0.007881s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (101822,609217,7843,380838,638736,376561,932181,537615,1045893,911578,221437,223844,323382,1028136,749833,374275,222713,1038849,277932,1008481,509135,872086,996017,45352,144855,592599,648625,371408,736464,174737,47634,113153,56430,160301,739107,525662,740386,613774,628696,390213,609138,392350,1011974,86837,324712,134614,329474,555910,488519,67421,839206,19077,413179,357387,148096,105058,610741,105088,693574,1030389) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002673s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 444651 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002110s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 444651 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]