SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001717s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 553822 LIMIT 1 [ RunTime:0.001244s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 553822 [ RunTime:0.002927s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (122314,341138,870618,473061,853433,759843,491253,190406,733192,954491,536072,860655,1017848,200105,195240,304925,446130,828430,73209,571428,1006422,771487,607936,334153,238865,920990,940706,801422,834524,50968,925408,809085,301427,365614,550157,832294,967803,683648,1027450,916385,326158,384344,271099,1041691,863165,814989,1014498,462197,387636,33812,227933,103383,274488,631618,404940,910010,879200,782380,1043086,499636) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 553822 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 553822 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]