SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 111243 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 111243 [ RunTime:0.001820s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (545771,576339,1046843,935618,569357,421083,433375,37211,49644,441557,624024,536401,629109,498001,215457,318764,632245,13694,695499,741976,782841,882936,118964,928540,399172,200915,456678,245106,746912,769472,1003221,42471,324216,283217,457907,477925,411886,695108,885791,10918,329909,592633,923794,861772,96680,95654,387173,204799,889280,640409,377322,1046039,988034,826939,343936,23893,536851,453365,751789,15058) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 111243 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 111243 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]