SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 800801 LIMIT 1 [ RunTime:0.000456s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 800801 [ RunTime:0.001635s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (978269,517618,435802,763570,1030590,703900,471926,118286,705384,1047497,245498,867374,453359,496002,920605,76115,819373,650497,77793,300435,39834,206844,301723,874781,1001074,233589,285205,174965,564386,604585,927626,913308,1036959,327659,119718,263230,671019,4000,944268,131141,170823,739257,1030540,53709,266618,137194,940112,1029492,769974,353053,313054,768923,923955,362228,310405,733806,287612,316109,484883,311751) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001006s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 800801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 800801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]