SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419764 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419764 [ RunTime:0.001815s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (940086,851866,684589,190551,669810,766149,252398,1029377,150759,194073,223845,538028,1044680,759488,1006171,703370,256838,862749,875917,735278,448477,225100,200811,303739,785196,425142,533563,714412,204988,817763,345593,158227,781266,1040488,604073,945614,517021,494902,110451,654884,693308,411116,424112,129868,835046,806343,597410,690973,85729,687742,216446,129921,569324,666610,219404,429560,265723,636436,30278,7129) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419764 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000522s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419764 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]