SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 10228 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 10228 [ RunTime:0.002227s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (712713,885340,973860,599417,558927,100909,338089,824441,628196,687565,774336,297006,330540,924255,43526,160262,297253,278165,533282,209266,575088,997430,940024,188358,231114,267357,876417,302249,700800,880696,449605,564068,86622,451739,120121,116702,853698,552755,337850,305050,437646,778468,640923,687501,452076,226898,156827,696876,820234,1014441,49361,856494,422762,801059,306149,1021032,587262,25109,415352,62451) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001311s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 10228 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 10228 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]