SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509684 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509684 [ RunTime:0.001633s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (48916,995539,324710,428202,90127,730703,851400,57371,556440,417592,663924,501090,249983,522068,758399,94686,761948,476051,1013021,171816,273246,431221,840962,289025,607763,81365,496005,994395,978720,280565,938077,214525,540294,411304,497222,484167,317599,92981,275312,473117,463704,590697,373473,59265,691651,1012758,55521,12707,795811,510991,951432,36547,949329,171105,777159,878667,240225,555081,143352,1014625) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509684 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509684 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]