SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004930s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 303947 LIMIT 1 [ RunTime:0.003730s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 303947 [ RunTime:0.003453s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1005909,144041,199854,897021,379423,804828,815714,454706,961217,411283,553868,373968,697406,748739,288450,71027,1028011,730158,169194,182975,264224,940263,566758,357176,551673,648878,952590,582390,514566,632024,368041,319059,274515,139802,109076,333383,877507,839898,415680,195353,579061,694135,753965,312195,967346,724711,731512,412691,794414,310890,369156,149367,89643,476580,359778,87526,473366,692344,992506,577235) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002152s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 303947 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 303947 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]