SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 800518 LIMIT 1 [ RunTime:0.000457s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 800518 [ RunTime:0.001841s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (292268,950356,692903,382335,550395,637125,808296,927179,1021141,704821,800446,21649,693962,462254,467800,969654,338877,552595,885353,844171,163035,279333,60580,1014286,853088,395288,592718,792836,98628,145723,752261,174062,264816,449238,162605,965084,661660,1005286,1002003,272198,439076,826054,129114,1039945,308240,869367,214375,266082,931347,409471,950705,348364,160283,1031237,999557,827543,750401,690628,566250,587955) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 800518 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000623s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 800518 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]