SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 491511 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 491511 [ RunTime:0.002202s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (351391,404187,330813,347862,282399,545901,935041,474450,292173,863914,756797,176337,251406,479673,219856,1014181,385440,385676,251683,1029014,242874,904533,910426,142558,356152,808192,72023,509040,926578,1013498,792281,895798,820205,524188,793011,1009685,16137,783862,524801,140184,419397,791476,677504,601740,129343,876740,1017337,32295,95157,578611,321208,609246,66314,397421,551579,947351,783604,928291,724360,154732) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001321s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 491511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000595s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 491511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]