SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001335s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416921 LIMIT 1 [ RunTime:0.000470s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416921 [ RunTime:0.001894s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (400434,727798,514478,478639,675466,829148,288653,345010,680376,1009239,293361,786404,805058,942001,107542,1002733,634624,863448,1028549,495876,642432,566611,473759,766796,699126,979550,134307,717861,48135,700110,235243,273550,65555,221501,541043,164933,793275,90092,814111,632058,975356,78220,912966,304176,202219,318270,435148,252003,891838,140688,259490,417800,503334,376127,877094,9862,288588,899131,98750,523665) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416921 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000469s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416921 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]