SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 681651 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 681651 [ RunTime:0.001970s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (487715,885457,737704,823677,662697,335853,200009,620095,512092,461283,428759,488371,706558,483330,303959,331015,678979,201165,931801,435768,838416,442433,910754,752857,423578,111166,243426,569018,779962,519076,191156,675025,867380,687642,723230,543098,254596,163635,20367,884285,43261,559202,749654,716227,522499,172453,947554,347241,1008337,524200,594931,765110,735351,737632,671807,910179,789568,694183,892933,48789) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 681651 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 681651 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]