SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001581s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 579303 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 579303 [ RunTime:0.001990s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (498128,893340,393446,1034831,449838,95978,2295,173977,1019976,757614,854036,806859,622003,751376,1047675,334700,204184,874779,1016498,288637,187189,473655,198561,202497,63421,893165,542151,22534,369220,966834,835707,521428,1010657,707869,822988,116999,894924,646171,702211,989850,710765,830719,253624,908671,955415,162175,166479,339696,791572,1014228,874613,1022520,417406,918664,122156,376949,727208,708638,1001107,149416) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001005s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 579303 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 579303 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003933s ]