SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 527921 LIMIT 1 [ RunTime:0.000507s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 527921 [ RunTime:0.001865s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (488012,907680,727707,223377,63830,579144,181149,731460,90591,460062,676850,959751,831712,635336,228555,428640,968857,739970,894583,850323,607419,87815,216663,918217,28400,200567,346800,1022839,142147,814182,985341,268637,363362,832146,210018,741498,261209,976539,123689,627169,811085,1019139,405059,327446,310411,912016,349364,467799,248443,451495,685092,157686,124016,380873,519970,847332,310645,1016802,12859,1010600) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 527921 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000506s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 527921 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000651s ]