SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417831 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417831 [ RunTime:0.001689s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (861309,1018341,547344,663274,351662,797409,932830,308161,702942,169276,342548,143716,450139,956268,1003115,932319,143148,48721,183449,33496,824080,89981,817777,497312,465062,69217,132370,244876,68659,244720,112694,1015167,542647,810831,103576,253144,294029,246339,797206,793662,871774,548077,874486,793024,372419,863115,458198,719891,562898,874977,586729,381070,1047574,1015855,745741,371020,941672,738155,212781,876902) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417831 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417831 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]