SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1025089 LIMIT 1 [ RunTime:0.000723s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1025089 [ RunTime:0.004754s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (552195,84203,867858,470398,195862,977438,273775,318462,1034744,578597,748360,102558,39738,842703,106263,1033203,307011,895672,987649,567998,774432,990778,826860,821364,530807,488252,92273,1036485,556096,200036,1007384,878295,710494,262656,588650,459396,597442,439010,629450,203838,259064,426164,246884,635280,1000589,538004,855549,587500,440465,139675,899936,598162,856359,771024,673433,580824,336762,436595,981183,259921) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001757s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1025089 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1025089 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]