SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001556s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509490 LIMIT 1 [ RunTime:0.001629s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509490 [ RunTime:0.004156s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (35949,204455,261226,897082,688975,608285,181115,861241,438593,639499,175960,736916,326397,252866,105358,336501,748303,321218,733925,644378,270777,634702,953796,882028,486079,403731,920049,803172,366912,785862,928498,74184,529268,70200,293638,579831,823979,687829,182151,678080,311973,571457,659198,950086,942464,654134,714721,907569,285335,493082,912941,904871,327401,1013592,871225,326819,411332,433832,60057,178719) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509490 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509490 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]