SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001365s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 340656 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 340656 [ RunTime:0.003643s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (112604,967595,87810,686233,227964,477810,73806,130773,388554,899882,479739,762030,630316,51224,521748,279331,685841,264912,910655,547961,406123,343403,754217,936252,826496,91260,539576,208600,663488,397981,63134,982767,965832,633893,269103,979597,955145,188642,229303,13785,753784,786374,394751,289288,253796,476005,747347,290812,416319,617131,1029636,440284,975994,989946,838823,630757,180056,975586,734134,377168) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 340656 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 340656 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]