SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001946s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514904 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514904 [ RunTime:0.001994s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (860153,783955,881397,412648,641374,71025,942050,458545,565935,185133,812201,338693,1047472,849774,7226,299003,1008826,146112,230125,493715,231539,409675,66404,964342,947385,830542,739365,513949,489332,739454,21716,200251,861846,319714,751224,250881,961526,766076,133078,373946,1013791,390893,572257,191182,559260,802582,910338,952024,601601,779320,402588,647413,797317,772374,999400,61941,505537,872384,707397,729848) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003057s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514904 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000531s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514904 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000498s ]