SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001431s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 497400 LIMIT 1 [ RunTime:0.000437s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 497400 [ RunTime:0.001738s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (45928,10102,1002638,544461,149498,943931,101180,325828,124647,742352,191446,498839,1017935,779380,716556,825982,252693,845685,462879,829377,432450,791239,1024247,674188,347213,932127,962970,520612,546163,351142,499815,546478,765603,530808,43359,850069,162980,253412,670883,1031212,904510,19403,874582,74010,980965,774906,544801,288368,259942,415210,21100,953687,723317,944795,988274,664166,379657,502116,870179,567974) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 497400 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 497400 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]