SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 554300 LIMIT 1 [ RunTime:0.000506s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 554300 [ RunTime:0.003143s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (403334,137033,690687,625091,749711,347455,226450,814989,109800,96536,802216,414094,803171,979674,430489,559776,261160,69024,775013,375930,585159,540225,698698,709370,750502,881853,676069,849984,697400,228526,968854,751977,406639,326268,442308,691128,1017315,211400,45495,838244,749487,354682,318880,645609,156939,318609,650146,155835,263265,781829,847031,733042,708551,551354,372951,407186,197447,318848,809231,414596) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 554300 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000939s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 554300 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]