SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 559896 LIMIT 1 [ RunTime:0.001253s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 559896 [ RunTime:0.002342s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (128907,556428,674691,849219,225874,242984,715333,697140,288810,210841,76045,1008628,511639,503293,960695,609552,822163,698987,986941,485984,972153,62147,676829,396811,248656,505027,925082,728530,915323,951786,545469,114093,699264,279692,417194,285111,310786,236627,441828,811829,44258,59846,443760,762831,597709,690177,820264,431267,136046,408387,666271,525341,155496,373970,420303,19248,817351,201143,899923,380435) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 559896 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 559896 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000495s ]