SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003631s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 248413 LIMIT 1 [ RunTime:0.000459s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 248413 [ RunTime:0.003895s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (130487,201001,726676,1037518,696780,231386,232579,321057,871462,340140,89305,248839,142925,301118,861575,96213,248862,3419,263334,366688,90468,820026,530538,119995,643194,966043,56516,937640,958093,352704,558919,633066,332962,123315,46918,812305,941251,969464,505859,14330,396398,598072,949052,406757,366592,159160,335152,255933,696558,1020446,250212,773581,397340,764467,282659,351013,765740,440043,279493,431445) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 248413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 248413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000498s ]