SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 425571 LIMIT 1 [ RunTime:0.000509s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 425571 [ RunTime:0.002284s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (702025,950187,113578,236114,700641,397569,416531,441175,135665,858239,411247,857197,632512,496537,166930,507097,261277,1047014,1046838,348160,215582,400801,799906,840266,970418,895873,440511,343975,227325,654258,612395,242239,524908,1008240,1029846,835380,351806,962156,408669,66380,728273,407248,319626,512899,166846,484712,625744,739679,337788,239863,649485,634205,275085,660539,789560,542103,308826,326208,379457,1014329) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 425571 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000707s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 425571 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000616s ]