SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 440580 LIMIT 1 [ RunTime:0.000552s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 440580 [ RunTime:0.002000s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (572120,562676,808530,1019731,624182,1038717,986914,572671,124561,583510,127155,609786,119980,86078,515711,542485,199657,134385,1024507,953025,910141,787365,294242,172702,732649,398022,738815,1038784,357478,887582,494026,889230,88381,556034,22822,778322,52524,382609,294482,1029553,320522,1531,846588,784846,656187,639811,937055,846354,1023792,339516,318733,154144,911337,438748,154754,911381,611823,609670,967468,782854) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007172s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 440580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000549s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 440580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]