SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001345s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520049 LIMIT 1 [ RunTime:0.000974s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520049 [ RunTime:0.001596s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (706036,482274,271131,606063,45399,206107,733402,795947,306583,932311,155916,917738,881145,963838,377310,759109,266027,999795,800576,821297,627603,10520,876246,935161,830669,46546,61909,953387,758147,817076,570804,398219,853161,176080,488100,386721,473570,423522,389521,889491,433395,669150,407181,328834,919190,887815,638630,520686,368659,207834,685526,293057,174407,1043053,690657,725013,926051,598949,966013,615844) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520049 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520049 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]