SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419957 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419957 [ RunTime:0.001693s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (669747,1040531,1041522,440343,1005134,437416,590121,395436,928686,372183,794456,615622,362279,515917,170222,1043957,879269,311438,976532,1030312,773813,251401,200870,193259,449396,426707,791458,356291,591445,678686,58264,749271,333588,79007,831476,784943,498439,451887,542252,138210,457045,965493,121919,536141,364333,943940,479331,397434,1024796,977877,341974,416840,757694,599063,684006,36706,277933,404218,469024,26130) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419957 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419957 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]