SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047880 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047880 [ RunTime:0.005191s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (821401,43569,224967,69947,597765,712538,199432,930479,414442,26219,169545,502535,325880,82500,537629,454408,659454,86645,339467,785885,512085,811922,200508,951531,347157,30953,852856,504537,310141,326251,442427,11896,232922,247537,122014,770114,425328,788133,99122,173157,548410,109836,607065,898800,532792,206373,968476,860222,434799,35178,932463,1003689,1027811,914643,68148,68473,464582,196700,718457,286766) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047880 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047880 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000429s ]