SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804941 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804941 [ RunTime:0.006231s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (673505,356411,899644,248104,230435,548555,617985,185965,1045055,437036,263274,652637,424928,744692,1013219,811206,496067,703270,553035,886231,642400,366326,1015970,931160,614159,114854,811871,360010,964882,143816,694170,747132,591122,473670,420094,295015,397564,772678,727348,179554,911640,363174,1010688,157788,921238,258881,428392,306509,753060,60697,408556,267850,28878,153977,155756,857881,683352,841440,13667,50255) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804941 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804941 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002700s ]