SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 910101 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 910101 [ RunTime:0.001593s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (440304,199280,940507,1018443,899759,1020022,941084,329038,645364,588023,912988,872520,900445,80557,467325,475087,161093,68736,585409,549888,259891,446031,91619,347764,675675,760667,250564,641741,631175,696023,384634,1038479,976012,911778,890773,669892,643756,1021366,376879,472026,773941,522482,186987,190285,691842,70864,362843,1252,657957,273834,955698,380163,603422,1009097,363168,148868,739151,660250,585553,149517) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 910101 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 910101 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000632s ]