SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407893 LIMIT 1 [ RunTime:0.000558s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407893 [ RunTime:0.004858s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (40216,623811,887618,90060,917586,246740,252764,442130,30374,581218,1046275,915306,1015068,922027,135952,547791,637103,684855,762691,28091,754148,499756,195332,183782,812080,176651,635261,759579,1046249,479508,220865,929701,763747,768172,579145,728619,800565,681665,989015,695218,692287,917704,955661,204782,127575,341783,759946,13577,320297,624433,882677,46534,985739,698433,33820,204862,673805,122132,123654,890753) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001664s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407893 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407893 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002346s ]