SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 550383 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 550383 [ RunTime:0.001584s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (229227,971471,316304,970595,917719,770619,825433,191560,534282,189814,256910,152305,846038,376725,725099,113470,740614,226761,1023329,186494,356718,605467,402299,399718,556428,875079,585069,672122,27365,65230,838507,834486,283081,888862,330999,79431,855051,898739,936021,853130,316891,452558,208371,827523,848592,334188,86660,371214,803814,78855,368960,665501,587354,87921,977691,713234,1006427,217659,508689,761191) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001602s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 550383 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 550383 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002707s ]