SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417710 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417710 [ RunTime:0.001739s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (557080,468421,758643,504728,849528,969037,662387,452099,152723,788446,68756,273721,746016,22481,485130,855593,556605,559472,110178,734130,451529,959201,428453,813547,825406,780470,887621,954416,510100,305192,334107,623358,409326,426694,726270,918311,28459,448885,461654,877481,725781,373963,225306,58165,906219,574947,354714,485990,577403,148829,103595,570421,185006,150392,747125,567681,738517,605099,501271,936627) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417710 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417710 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]