SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 167341 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 167341 [ RunTime:0.001945s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (912759,848565,193983,140988,215386,742635,386123,1043005,180561,731161,811001,767204,1014752,174752,669885,191130,1012514,816889,533542,492005,299346,542499,815623,893471,208027,990651,12165,772233,73724,646764,716242,821886,909379,801799,991841,399847,256050,792973,644643,993594,243803,304021,930438,687223,1034064,491271,1048173,909763,321486,787267,971506,537619,973296,220482,285141,484445,443324,478129,844073,341981) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 167341 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 167341 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000463s ]