SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 465254 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 465254 [ RunTime:0.002026s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (165280,108333,151974,711151,388963,846044,850226,819662,568903,786041,474833,946330,527432,75963,248298,59890,406370,729897,416041,565734,987012,85583,742041,440814,237147,825933,935135,58130,805224,1047131,728082,995867,1022790,557944,491033,245105,889656,335139,931165,453693,568462,202697,936011,749913,275243,136345,504426,593382,783941,25268,480915,525781,954579,360142,878966,858574,819915,1004103,443266,934183) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 465254 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 465254 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]