SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541280 LIMIT 1 [ RunTime:0.001102s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541280 [ RunTime:0.001623s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (890529,802554,406847,284134,948378,657620,243668,1019916,730085,415467,779288,576243,664150,630478,850136,763412,292111,744645,546285,860060,776233,68831,110415,885505,739491,74266,522161,1028719,42698,284973,25587,371578,331362,634661,457001,182393,744315,39833,701660,184515,811721,446306,853711,514277,868941,1038951,243857,242372,603236,356004,279158,734387,99494,816396,617122,1007923,523593,126408,29603,442641) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541280 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541280 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]