SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410117 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410117 [ RunTime:0.001838s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (918887,97442,831757,744504,553031,355108,554522,1012046,161747,67411,22773,171444,1038174,704492,297272,1014130,664820,451527,392094,1009264,851142,923476,438900,1048705,444096,287730,304265,359807,146762,552581,141265,1029212,122672,407358,549532,984165,352273,647532,311853,787578,418515,61333,613814,544848,326064,782984,247874,898395,112665,638941,56801,545935,710428,661627,788557,429500,132632,914135,164997,174025) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410117 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410117 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]