SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 408102 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 408102 [ RunTime:0.002158s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (294930,825074,1029783,1047984,1021719,50280,515132,523579,276110,247385,300374,22384,296849,364804,7251,318549,439000,125434,9855,806726,314675,20108,1010650,438644,430028,105311,384772,37478,212687,488290,337552,43430,409073,676451,163207,840011,794808,271561,290401,346877,371478,34278,651462,591375,641585,432834,503151,333816,395549,1046486,774333,1012934,552778,309833,844259,324100,910678,620834,1032988,239715) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 408102 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001565s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 408102 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]