SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 451601 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 451601 [ RunTime:0.001454s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (937183,633087,484507,40788,15567,794957,623477,551958,382874,242595,611744,997880,367423,327352,278746,912066,716061,275631,87973,161090,117828,988323,797550,654422,667635,96445,228690,130881,143417,806364,694085,766571,1006869,1017333,1022982,298456,378308,1046184,199882,520235,879870,385919,417969,853828,412102,330610,474530,961628,733343,635572,682486,120488,371131,325914,854587,703400,75130,1004720,168097,386211) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000968s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 451601 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 451601 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000399s ]