SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506828 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506828 [ RunTime:0.001893s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (830207,599468,915710,838409,717399,355004,651212,227491,992387,986345,45944,941094,508593,1018117,786587,685137,136135,500499,619826,981367,720795,521077,1038593,165347,496904,954400,278155,360383,1019344,266901,589317,786345,226083,588217,252027,749424,136636,44690,248914,1037411,75818,704280,308054,712209,1045542,859935,643406,116405,485544,960613,426205,821519,586258,247353,134003,911694,192328,149800,212072,961253) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506828 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000484s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506828 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]