SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001337s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506877 LIMIT 1 [ RunTime:0.000459s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506877 [ RunTime:0.002002s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (9200,183149,795484,203839,757373,1012276,813806,296916,870219,751069,226579,393437,339227,255637,749365,253138,1040878,1036849,56203,643845,964538,484847,52302,284890,83472,978310,537838,483790,638599,275019,776936,143960,646691,612421,845835,885216,807381,822147,251234,805425,471218,462654,252956,939793,114580,271858,583362,96418,595374,198753,94558,621885,324449,97878,617394,743947,46702,244665,959052,402088) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001521s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506877 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000496s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506877 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]