SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 575082 LIMIT 1 [ RunTime:0.004430s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 575082 [ RunTime:0.004180s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (586839,890135,228890,356383,508657,938522,748359,289311,640216,1025375,605491,213038,311673,392310,304826,648380,449182,916101,313018,837270,594825,403500,585289,463972,583948,243265,646992,191231,546151,506580,240101,821846,439468,566738,952450,825175,233838,857453,209220,662033,63090,763890,257399,975995,926238,99365,547140,151132,33991,845971,230247,810737,79488,262259,1016680,204865,760739,373602,366925,299243) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 575082 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 575082 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]