SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002441s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 488396 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 488396 [ RunTime:0.002093s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (821398,279873,615497,932657,543318,502004,945104,380594,633566,207958,201028,107705,958074,422350,192466,426174,110845,761559,971107,149862,836372,199960,156088,801387,744884,385334,698195,423166,62559,982175,871669,310499,828622,846266,435802,604940,171346,592114,443728,854862,404939,630803,816729,705167,103861,832894,1048904,630593,671283,633463,145363,667280,49350,797100,650356,422712,878603,83418,480786,643482) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 488396 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 488396 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001829s ]