SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043211 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043211 [ RunTime:0.001758s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (618142,946150,912190,405422,889947,945634,25784,532062,456377,880086,118588,456192,721278,376041,852864,320953,462491,332975,394622,1048922,966406,369598,404997,283387,853404,501774,343173,536121,201074,426589,702861,139595,223242,722916,1026462,780851,343556,349821,14294,612928,656520,760752,230502,41812,904802,812782,481554,283498,948464,836038,271645,731191,37871,440221,577553,45651,369055,642165,116476,918179) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002503s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043211 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003215s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043211 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001155s ]