SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002429s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40589 LIMIT 1 [ RunTime:0.000570s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40589 [ RunTime:0.006376s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (180280,382586,218139,361813,450629,103162,639807,728195,606494,135713,745120,180411,1007382,353582,854190,842888,118924,1034087,268402,552628,930793,984571,283490,25843,701120,157066,289037,376572,508553,481892,148116,211664,736278,991389,605474,969151,272475,99358,561052,262693,398969,799775,389714,274979,24925,879219,800649,764373,338173,256862,780940,916507,196840,77935,707394,916585,553473,221912,276699,348852) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40589 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40589 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004727s ]