SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001486s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 150601 LIMIT 1 [ RunTime:0.000465s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 150601 [ RunTime:0.001601s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (680479,780035,650595,307781,313298,240790,185281,1042797,608030,151885,486229,1005905,279085,532511,365736,132890,996098,459869,961759,109348,1040847,35668,487925,565221,98872,99328,746592,953263,858335,375287,264362,72678,32701,455547,730596,834486,628428,790884,649202,290662,329355,745924,896573,61074,329564,791867,201211,463747,371430,579184,837604,188785,880210,204814,1002840,130008,995604,765826,143399,105874) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 150601 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 150601 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]