SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002081s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043922 LIMIT 1 [ RunTime:0.000556s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043922 [ RunTime:0.001484s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (161438,624634,990632,250652,721658,476127,75104,366127,149856,867679,314247,727369,864986,871782,168050,606007,661967,870824,63148,350184,243751,343646,13565,1008232,234335,142656,964769,590186,755344,970639,277046,950224,614184,139650,586815,741297,552520,621063,151880,493948,780935,481955,361778,940141,620407,301827,490157,608203,628902,276750,850251,565292,99324,244019,866785,944611,914115,323640,517460,369401) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043922 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043922 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]