SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001486s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 280711 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 280711 [ RunTime:0.001961s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (849851,510453,383180,754623,316027,828487,1027414,316220,347412,383940,876592,595594,120055,241315,148191,810865,42442,303631,205349,872268,118868,783329,891774,116441,910503,49910,835415,350090,446708,437346,994456,189617,867582,664309,341242,1011585,558368,501079,395907,885042,31658,607567,483555,62820,669346,456274,86189,955442,626717,964154,4886,783193,82755,724725,703195,23343,502890,863618,951347,261076) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 280711 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 280711 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]