SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507309 LIMIT 1 [ RunTime:0.001902s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507309 [ RunTime:0.007231s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (322786,790090,5161,620374,1017483,405527,558999,578969,756427,641340,237298,960139,535237,410443,545206,924339,730319,662693,163543,771835,390521,649446,650463,119846,240005,624279,391283,275444,169453,957219,284791,801392,288637,284036,452714,158814,257890,1043648,108530,478844,739034,276534,354767,53748,219261,681812,1000300,376032,244845,578557,719839,43225,606664,39030,558194,161025,700999,611249,79398,646561) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.036767s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507309 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000959s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507309 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003365s ]