SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 436580 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 436580 [ RunTime:0.002381s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (395299,514342,364365,984012,984098,182641,493183,87685,39352,1009288,70842,901596,763196,30605,748457,141438,699030,697570,1026531,209634,783286,775848,150209,875278,301034,22342,742477,665295,951784,838453,299303,216006,88179,209404,107866,768522,568741,412502,1042433,246054,1032730,512215,261445,657937,416825,665968,475446,483057,263890,549335,382344,855812,934973,320174,471033,6461,21368,389772,268447,463682) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 436580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000485s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 436580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000433s ]