SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 519581 LIMIT 1 [ RunTime:0.000277s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 519581 [ RunTime:0.001625s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (764040,88674,527732,150111,328448,581849,275546,543320,692883,846828,853710,1040871,506115,740805,332836,278576,30895,999215,339410,508735,7514,277635,995552,615301,827584,344013,259092,322598,887384,654722,695109,1009608,669765,182269,315033,4184,925066,902134,1011184,96556,715238,17350,670332,202865,327521,65370,677941,810055,971740,871001,1027848,504189,121154,148389,697464,734231,886358,75208,169460,438412) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000993s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 519581 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 519581 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000420s ]