SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 512003 LIMIT 1 [ RunTime:0.001822s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 512003 [ RunTime:0.003710s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (519788,717504,422685,655008,747757,867348,137483,333310,964314,311152,140319,920571,291579,393125,774039,116361,315884,857449,759505,742016,350588,198756,444900,373159,533621,1000720,890892,383163,336045,122850,33860,697327,348320,947070,62434,908635,70309,129096,87681,752457,57742,305836,726299,864730,921808,856733,609582,473635,10585,521247,563297,612511,232916,154913,328558,670335,114551,396068,940753,281581) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.029625s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 512003 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000970s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 512003 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003160s ]