SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001315s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501623 LIMIT 1 [ RunTime:0.000700s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501623 [ RunTime:0.001784s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (279567,312181,143348,303758,1006836,991557,463666,355544,264579,750731,289085,950432,822804,973512,816264,153878,879443,51158,201351,248848,617732,852825,358380,277556,422447,264140,69357,891435,785349,847088,905662,974326,893638,908288,903269,984058,122647,434704,820379,808321,926244,474684,343741,799050,621424,426729,538810,664027,559022,461575,1017192,633489,1044418,949051,857210,734669,739481,466106,836427,125355) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501623 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501623 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000471s ]