SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.007484s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 441254 LIMIT 1 [ RunTime:0.006992s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 441254 [ RunTime:0.007588s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (862124,38159,707290,302327,701035,527134,206970,950781,239088,163760,413373,392336,315041,377981,521385,914659,869717,819123,568224,627281,61472,261434,914020,464940,1035484,643567,817975,113709,670485,322815,276715,506036,662500,1006320,975074,1008678,398063,1032621,694287,889644,212901,358811,934636,580134,119243,609557,599910,986102,944455,522,79551,446931,720069,200629,770476,250865,356491,138831,233092,718097) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002855s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 441254 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000695s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 441254 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.005216s ]