SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413199 LIMIT 1 [ RunTime:0.000442s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413199 [ RunTime:0.002045s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1041888,591493,454596,212669,341597,1021171,679032,539605,571864,778594,985670,85354,250501,649219,391475,56787,142755,330264,915369,750047,118116,571960,291425,945485,707682,259190,488077,515922,810261,680977,316625,958334,278689,768529,422568,1041720,238223,5611,294708,163113,800825,311246,987734,784571,554260,830531,46061,698105,1015151,714769,115635,802618,421661,778971,599356,601991,1035694,193953,153398,578087) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413199 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413199 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000558s ]