SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040967 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040967 [ RunTime:0.001841s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (468147,516392,842037,247826,614297,1043623,759248,854744,317461,673278,843014,573566,36838,259636,355957,189640,849982,17387,979513,864916,273004,735210,122776,201727,1012899,146686,772450,757871,712292,928349,215996,34026,189688,559223,194016,826630,778205,841819,199021,269110,283227,1012253,1041553,346101,585741,227462,743107,942190,778314,528465,923457,528241,750234,600116,281097,495949,331342,54956,440904,65462) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040967 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000580s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040967 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002436s ]