SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002630s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 689704 LIMIT 1 [ RunTime:0.001812s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 689704 [ RunTime:0.002468s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (282065,510008,162286,124408,631807,354663,330319,7370,858178,472579,231966,230080,946420,607546,362769,228127,478930,473117,1033164,850991,751462,708693,90086,796752,931480,744125,461899,69642,190056,799914,422280,149225,682742,478618,58675,678684,802805,832462,54295,283067,505555,750483,441259,850270,203372,144119,342707,647518,977756,451979,588143,102208,12136,870438,177600,1036760,228638,661845,737633,469213) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 689704 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 689704 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]