SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001427s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 642454 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 642454 [ RunTime:0.004601s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1021833,132009,158844,283790,854574,121289,732496,906849,45693,472531,752762,197944,314472,140640,213425,523169,22972,282765,642116,906617,707818,414656,336123,770015,97839,557558,696447,375490,996722,1040454,351601,386933,547329,107386,930275,206812,637954,304443,163384,433561,753977,931443,255960,538677,389062,104608,438980,1029434,10218,566026,746133,367849,591445,356728,88551,365379,830528,787097,953558,122853) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 642454 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000494s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 642454 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000491s ]