SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001294s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506995 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506995 [ RunTime:0.002289s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (111295,386939,391335,236529,536809,695175,234751,612824,574996,891643,524503,616609,1024373,483953,631706,263660,860420,634455,424608,546318,993057,660518,236958,449455,854975,871443,486295,1022333,571728,952579,124604,557688,83478,143469,101852,440754,939429,73217,802767,473009,371399,143762,916978,517179,69180,363995,214537,582155,256034,676215,569962,655817,474516,430703,136191,752740,757861,596151,381575,768804) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506995 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506995 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]