SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003916s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542064 LIMIT 1 [ RunTime:0.001751s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542064 [ RunTime:0.002681s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1002553,961114,581631,536093,999075,535924,734502,883330,400405,642901,436195,819614,988878,771318,562459,128230,908524,449272,651316,515166,937913,94498,438562,537649,179413,1041991,8465,980149,335600,874854,867751,68161,885384,200598,111500,376606,454497,722124,679723,260486,958021,722867,239973,663496,576272,545349,214609,218944,98001,717596,886283,837855,1003702,465677,600113,695065,288902,864172,552079,578942) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542064 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542064 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]