SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001408s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 143231 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 143231 [ RunTime:0.002059s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (822010,583481,906054,217611,387894,284123,63733,475441,1019993,534317,74657,534127,903751,217498,681820,825401,294255,395868,554094,434320,714773,271322,100778,767584,204384,577007,541231,554291,333065,705315,723485,715339,836958,640049,281511,312148,229751,348776,668868,823194,852458,79804,328293,542541,934080,945791,349807,547893,986231,542370,864856,139118,512933,190108,194941,196802,950587,75368,654471,370207) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001290s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 143231 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 143231 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]