SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001934s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544716 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544716 [ RunTime:0.001922s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (819447,7319,1017569,928053,118627,548117,649747,595700,282023,729919,918583,606699,983238,735323,190182,269169,537090,344216,133089,619868,1043315,182666,614402,1025297,63561,992588,625276,754439,709074,206137,985346,396338,73061,759675,275801,597107,274938,642699,310891,49548,962645,858914,46294,66176,426267,595007,960123,785743,991249,901358,516363,130656,469278,1012191,888651,943560,170393,434692,733509,973281) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544716 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544716 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]