SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407689 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407689 [ RunTime:0.002930s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1041781,969486,690180,111115,1003083,698139,938208,535998,707896,1030052,665311,657747,674408,637402,951294,244518,1009363,492228,962476,520660,1033674,663278,137614,191861,505027,418408,996785,726187,681479,223742,93588,560202,888892,980709,533975,33467,349461,43424,119004,809077,478477,976825,867529,695287,633683,442237,478681,84176,844137,490768,585436,452736,733452,466500,231013,189895,222775,834851,770147,343144) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000960s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407689 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407689 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000481s ]